package com.bgIntlgn.client.entity.warehourse;

import yuhuibear.poat.annotations.relation.View;
import yuhuibear.poat.object.bean.Bean;

@View(name = "depositories_view", sqlToCreate = "select de.id as id, de.name as name, "
		+ "de.volume as volume, de.comment as comment, e.name as manager, dic.name as type "
		+ "from depositories as de, employees as e, dictionarys as dic  "
		+ "where de.manager=e.id and de.type=dic.id")
		
public class DepositoryView implements Bean {

	private Long id;
	private String manager;
	private String name;
	private String type;
	private Double volume;
	private String comment;

	public Long getId() {
		return id;
	}

	public void setId(Long id) {
		this.id = id;
	}

	public String getManager() {
		return manager;
	}

	public void setManager(String manager) {
		this.manager = manager;
	}

	public String getName() {
		return name;
	}

	public void setName(String name) {
		this.name = name;
	}

	public String getType() {
		return type;
	}

	public void setType(String type) {
		this.type = type;
	}

	public Double getVolume() {
		return volume;
	}

	public void setVolume(Double volume) {
		this.volume = volume;
	}

	public String getComment() {
		return comment;
	}

	public void setComment(String comment) {
		this.comment = comment;
	}
}
